MAINHACK

Viewing / Editing File: assign_class_teacher.php

<?php include("../functions.php");
 //error_reporting(0);
 if(!isset($_SESSION['dbmail_Xw211qAAsq4'])){
     header("location:../auth-login");
 } else {
   $s_code = $_SESSION['s_code_Xw2119904'];
$stmt = $con->prepare("Select * from schools where school_code = ?");
$stmt->execute(array($s_code));
$row = $stmt->fetch();
$logo = $row['logo'];
    if(empty($logo)){
      header("Location:complete-process");
    } else {

if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['submit'])) {
    // Get the selected teacher
    $teacher_id = isset($_POST['userid']) ? $_POST['userid'] : '';
    
    // Get the selected semester
    $semester = isset($_POST['semester']) ? $_POST['semester'] : '';
    
    // Get the selected classes
    $classes =  $_POST['classes'];

// Ensure inputs are sanitized
    $teacher_id = mysqli_real_escape_string($new, $teacher_id);
    $semester = mysqli_real_escape_string($new, $semester);
    
    // // Prepare the classes as a comma-separated string
    // $classes_str = implode(", ", array_map(function($class) use ($new) {
    //     return mysqli_real_escape_string($new, $class);
    // }, $classes));

$date = date("Y-m-d");

for ($i=0; $i < count($classes) ; $i++) {

if($classes[$i]!=""){

$class = $classes[$i];

// Insert all data into a single table
    $query = "INSERT INTO assign_class_teacher (teacher_id, sem_id, class_name,s_code,date) VALUES ('$teacher_id', '$semester', '$class','$s_code','$date')";

if (mysqli_query($new, $query)) {
           echo "<script>
document.addEventListener('DOMContentLoaded', function() {
Swal.fire({
title: 'Success!',
text: 'Class is assign.',
icon: 'success',
confirmButtonText: 'OK'
});
 });
</script>";
    } else {
        echo "Error: " . mysqli_error($new);
    }

}
}
}

if(isset($_POST['del'])){
$SID  = test_input($_POST['SID']);
$stmt = $con->prepare("DELETE FROM assign_class_teacher WHERE teacher_id = ?");
$stmt->execute(array($SID)); 
   echo "<script>
document.addEventListener('DOMContentLoaded', function() {
Swal.fire({
title: 'Success!',
text: 'Records deleted successfully.',
icon: 'success',
confirmButtonText: 'OK'
});
});
</script>";
}

}
}
?>

<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>ASSIGN CLASS TEACHER </title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">

<link href="assets/libs/datatables.net-bs4/css/dataTables.bootstrap4.min.css" rel="stylesheet" type="text/css" />
<link href="assets/libs/datatables.net-buttons-bs4/css/buttons.bootstrap4.min.css" rel="stylesheet" type="text/css" />

<link href="assets/libs/datatables.net-responsive-bs4/css/responsive.bootstrap4.min.css" rel="stylesheet" type="text/css" />

<link rel="stylesheet" href="assets/css/preloader.min.css" type="text/css" />

<link href="assets/css/bootstrap.min.css" id="bootstrap-style" rel="stylesheet" type="text/css" />

<link href="assets/css/icons.min.css" rel="stylesheet" type="text/css" />

<link href="assets/css/app.min.css" id="app-style" rel="stylesheet" type="text/css" />

<link href="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.13/css/select2.min.css" rel="stylesheet" />

.container {
    max-width: 950px;
    margin: auto;
    background: white;
    padding: 20px;
    border-radius: 8px;
    box-shadow: 0 2px 10px rgba(0, 0, 0, 0.1);
}

h1 {
    text-align: center;
    color: #333;
}

h2 {
    margin-top: 20px;
    color: #4CAF50;
}

.exam-form {
    margin-bottom: 20px;
    background-color: #f9f9f9;
    padding: 20px;
    border-radius: 8px;
    box-shadow: 0 2px 5px rgba(0, 0, 0, 0.1);
}

.exam-form label {
    display: block;
    margin: 10px 0 5px;
}

.exam-form input {
    width: calc(100% - 20px);
    padding: 10px;
    margin-bottom: 10px;
    border: 1px solid #ddd;
    border-radius: 4px;
}

.exam-form button {
    background-color: #4CAF50;
    color: white;
    border: none;
    padding: 10px;
    border-radius: 4px;
    cursor: pointer;
    transition: background-color 0.3s;
}

.exam-form button:hover {
    background-color: #45a049;
}

table {
    width: 100%;
    border-collapse: collapse;
    margin-top: 20px;
}

thead {
    background-color: #4CAF50;
    color: white;
}

th, td {
    border: 1px solid #ddd;
    padding: 12px;
    text-align: center;
    font-size: 16px;
}

th {
    position: sticky;
    top: 0; /* Keeps the header fixed when scrolling */
}

tbody tr:nth-child(even) {
    background-color: #f2f2f2;
}

tbody tr:hover {
    background-color: #e8f5e9; /* Light green on hover */
}

tbody td {
    border: 1px solid #ddd;
    vertical-align: middle; /* Aligns text vertically center */
}

/*table {
  table-layout: fixed;
  width: 100%;
}

td {
  word-wrap: break-word;
  word-break: break-all;
  white-space: normal; 
}*/

</style>

</head>

<body>

<div id="layout-wrapper">

<?php include("includes/header.php");?>
<?php include("includes/sidebar.php");?>
<div class="main-content">

<div class="row">
<div class="col-12">
<div class="page-title-box d-sm-flex align-items-center justify-content-between">
<h4 class="mb-sm-0 font-size-18">ASSIGN CLASS TEACHER</h4>

<div class="page-title-right">
<ol class="breadcrumb m-0">
<li class="breadcrumb-item"><a href="javascript: void(0);">Home</a></li>
<li class="breadcrumb-item active">ASSIGN CLASS TEACHER</li>
</ol>
</div>

</div>
</div>
</div>

<div class="row">
<div class="col-12">
    <div class="container">
       <button type="button" class="btn btn-primary waves-effect waves-light" 
data-bs-toggle="modal"
data-bs-target=".bs-example-modal-lg">Add new</button>
        <table>
            <thead>
                <tr>
                    <th>#</th>
                    <th>Teacher name</th>
                    <th>Semester</th>
                    <th>Class</th>
                    <th>Action</th>
                </tr>
            </thead>
            <tbody>
            <tr>
            <?php
            $cnt = 1;
            // $select = mysqli_query($new,"SELECT DISTINCT teacher_id,sem_id FROM assign_class_teacher WHERE s_code = '$s_code'");

$select = mysqli_query($new,"SELECT teacher_id, sem_id, GROUP_CONCAT(class_name SEPARATOR ', ') AS class_name
                FROM assign_class_teacher WHERE s_code = '$s_code'
                GROUP BY teacher_id, sem_id");
            while($get = mysqli_fetch_array($select)){
            ?>
            <?php  $edit_data = "edit_".$getdata["id"];?>
            <?php  $delete_data = "delete_".$get["teacher_id"];?>

</td>

<div class="modal fade bd-example-modal-lg12" id="<?php echo $edit_data; ?>" tabindex="-1" role="dialog" aria-labelledby="myLargeModalLabel" aria-hidden="true">
  <div class="modal-dialog modal-lg">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title" id="myLargeModalLabel">Update records</h5>
        <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
      </div>
      <div class="modal-body">
        
        <div class="container">
          <div class="row justify-content-center">
            <div class="col-md-8 col-lg-6"> 
              <form method="POST">
                <div class="mb-3">
                  <label for="exampleInputEmail1" class="form-label">Semester name</label>
                  <input type="text" class="form-control" name="updatehouse" value="<?php echo $get['semester'];?>">
                </div>
              
                <input type="hidden" name="id" value="<?php echo $get['teacher_id'];?>">
                
                <button type="submit" name="update" class="btn btn-primary">Submit</button>
              </form>
            </div>
          </div>
        </div>
      </div>
    </div>
  </div>
</div>

<div class="modal fade bd-example-modal-lg13" id="<?php echo $delete_data; ?>" tabindex="-1" role="dialog" aria-labelledby="myLargeModalLabel" aria-hidden="true">
  <div class="modal-dialog modal-sm">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="myLargeModalLabel">Delete </h5>
 <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
</div>
<div class="modal-body">
<form method="POST">
Are you sure you want to delete this?
</div>
<input type="hidden" name="SID" value="<?php echo $get['teacher_id']; ?>">
<div class="modal-footer">
<button type="submit" name="del" class="btn btn-success">Delete</button>
</form>
</div>
</div>
</div>
</div>

</tr>
            <?php }?>
               
             
            </tbody>
        </table>
    </div>

<div class="mb-3">
        <label for="exampleInputEmail1" class="form-label">Select Teacher</label>
        <select class="form-control" name="userid">
        <option value="">---SELECT---</option>
        <?php 
        $select = mysqli_query($new,"SELECT * FROM schools WHERE school_code = '$s_code' and user_name != 'Admin'");
        while ($getdata = mysqli_fetch_array($select)) {
        ?>
        <option value="<?php echo $getdata['user_name'];?>"><?php echo $getdata['user_name'];?></option>
        <?php }?>
        </select>
        </div>

<div class="mb-3">
        <label for="exampleInputEmail1" class="form-label">Select Semester</label>
        <select class="form-control" name="semester">
        <option value="">---SELECT---</option>
        <?php 
        $selectt = mysqli_query($new,"SELECT * FROM semester WHERE s_code = '$s_code'");
        while ($getdataa = mysqli_fetch_array($selectt)) {
        ?>
        <option value="<?php echo $getdataa['semester'];?>"><?php echo $getdataa['semester'];?></option>
        <?php }?>
        </select>
        </div>

<div class="mb-3">
    <label for="classCheckboxes" class="form-label">Select Classes</label>
    <div id="classCheckboxes">
        <?php 
        $selectt = mysqli_query($new, "SELECT * FROM class WHERE s_code = '$s_code'");
        while ($getdataa = mysqli_fetch_array($selectt)) {
        ?>
            <div class="form-check">
                <input class="form-check-input" type="checkbox" name="classes[]" value="<?php echo $getdataa['class_name']; ?>" id="class_<?php echo $getdataa['class_name']; ?>">
                <label class="form-check-label" for="class_<?php echo $getdataa['class_name']; ?>">
                    <?php echo $getdataa['class_name']; ?>
                </label>
            </div>
        <?php } ?>
    </div>
</div>

<button type="submit" name="submit" class="btn btn-primary">Submit</button>
              </form>
            </div>
          </div>
        </div>
      </div>
    </div>
  </div>
</div>

</div>
</div> 
</div> 
</div> 
</div>

<?php include("includes/footer.php");?>
</div>

</div>

<div class="right-bar">
<div data-simplebar class="h-100">
<div class="rightbar-title d-flex align-items-center p-3">

<h5 class="m-0 me-2">Theme Customizer</h5>

<hr class="m-0" />

<div class="p-4">
<h6 class="mb-3">Layout</h6>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout"
id="layout-vertical" value="vertical">
<label class="form-check-label" for="layout-vertical">Vertical</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout"
id="layout-horizontal" value="horizontal">
<label class="form-check-label" for="layout-horizontal">Horizontal</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Layout Mode</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-mode"
id="layout-mode-light" value="light">
<label class="form-check-label" for="layout-mode-light">Light</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-mode"
id="layout-mode-dark" value="dark">
<label class="form-check-label" for="layout-mode-dark">Dark</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Layout Width</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-width"
id="layout-width-fuild" value="fuild" onchange="document.body.setAttribute('data-layout-size', 'fluid')">
<label class="form-check-label" for="layout-width-fuild">Fluid</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-width"
id="layout-width-boxed" value="boxed" onchange="document.body.setAttribute('data-layout-size', 'boxed')">
<label class="form-check-label" for="layout-width-boxed">Boxed</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Layout Position</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-position"
id="layout-position-fixed" value="fixed" onchange="document.body.setAttribute('data-layout-scrollable', 'false')">
<label class="form-check-label" for="layout-position-fixed">Fixed</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-position"
id="layout-position-scrollable" value="scrollable" onchange="document.body.setAttribute('data-layout-scrollable', 'true')">
<label class="form-check-label" for="layout-position-scrollable">Scrollable</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Topbar Color</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="topbar-color"
id="topbar-color-light" value="light" onchange="document.body.setAttribute('data-topbar', 'light')">
<label class="form-check-label" for="topbar-color-light">Light</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="topbar-color"
id="topbar-color-dark" value="dark" onchange="document.body.setAttribute('data-topbar', 'dark')">
<label class="form-check-label" for="topbar-color-dark">Dark</label>
</div>

<h6 class="mt-4 mb-3 pt-2 sidebar-setting">Sidebar Size</h6>

<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-size"
id="sidebar-size-default" value="default" onchange="document.body.setAttribute('data-sidebar-size', 'lg')">
<label class="form-check-label" for="sidebar-size-default">Default</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-size"
id="sidebar-size-compact" value="compact" onchange="document.body.setAttribute('data-sidebar-size', 'md')">
<label class="form-check-label" for="sidebar-size-compact">Compact</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-size"
id="sidebar-size-small" value="small" onchange="document.body.setAttribute('data-sidebar-size', 'sm')">
<label class="form-check-label" for="sidebar-size-small">Small (Icon View)</label>
</div>

<h6 class="mt-4 mb-3 pt-2 sidebar-setting">Sidebar Color</h6>

<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-color"
id="sidebar-color-light" value="light" onchange="document.body.setAttribute('data-sidebar', 'light')">
<label class="form-check-label" for="sidebar-color-light">Light</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-color"
id="sidebar-color-dark" value="dark" onchange="document.body.setAttribute('data-sidebar', 'dark')">
<label class="form-check-label" for="sidebar-color-dark">Dark</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-color"
id="sidebar-color-brand" value="brand" onchange="document.body.setAttribute('data-sidebar', 'brand')">
<label class="form-check-label" for="sidebar-color-brand">Brand</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Direction</h6>

</div>

</div> 
</div>

<div class="rightbar-overlay"></div>

<script src="assets/libs/jquery/jquery.min.js"></script>
<script src="assets/libs/bootstrap/js/bootstrap.bundle.min.js"></script>
<script src="assets/libs/metismenu/metisMenu.min.js"></script>
<script src="assets/libs/simplebar/simplebar.min.js"></script>
<script src="assets/libs/node-waves/waves.min.js"></script>
<script src="assets/libs/feather-icons/feather.min.js"></script>

<script src="assets/libs/pace-js/pace.min.js"></script>

<script src="assets/libs/datatables.net/js/jquery.dataTables.min.js"></script>
<script src="assets/libs/datatables.net-bs4/js/dataTables.bootstrap4.min.js"></script>

<script src="assets/libs/datatables.net-buttons/js/dataTables.buttons.min.js"></script>
<script src="assets/libs/datatables.net-buttons-bs4/js/buttons.bootstrap4.min.js"></script>
<script src="assets/libs/jszip/jszip.min.js"></script>
<script src="assets/libs/pdfmake/build/pdfmake.min.js"></script>
<script src="assets/libs/pdfmake/build/vfs_fonts.js"></script>
<script src="assets/libs/datatables.net-buttons/js/buttons.html5.min.js"></script>
<script src="assets/libs/datatables.net-buttons/js/buttons.print.min.js"></script>
<script src="assets/libs/datatables.net-buttons/js/buttons.colVis.min.js"></script>

<script src="assets/libs/datatables.net-responsive/js/dataTables.responsive.min.js"></script>
<script src="assets/libs/datatables.net-responsive-bs4/js/responsive.bootstrap4.min.js"></script>
        <script src="assets/libs/sweetalert2/sweetalert2.min.js"></script>

<script src="assets/js/pages/datatables.init.js"></script>

myModal.addEventListener('shown.bs.modal', function () {
myInput.focus()
})
</script>

</body>
</html>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: assign_class_teacher.php

Server Info

System Features

User Info